package com.vhr.VO;

import lombok.Data;

@Data
public class SalaryVO {

    private Double baseSalary;
    private Double leaveFine;
    private Double illegalFine;
    private String payTime;
    private String empName;
    private Integer empNum;
    private Double foodSalary;
    private Double houseSalary;
    private Double travelSalary;
    private Double monthBonus;
    private Double overtimeSalary;
    private Double realSalary;
    private Double tax;
    private Integer salaryId;
    /*奖励工资          "award": 1400,
    基本工资          "basic": 5000,     contract.base_salary
    考勤扣除          "check": 334,    salary.leave_fine,salary.illegal_fine
    时间　　          "date": "2019-09",    salary.pay_time
    姓名　　          "empName": "jacket",　　　employee.emp_name
    编号　　          "empNumber": 1001,　　　account.emp_num
    食物补贴          "food": 200,　　　　welfare.food_salary
    住房补贴          "house": 200,　　　　　　welfare.house_salary
    奖金　　          "monthBonus": 500,　　　salary.month_bonus
    加班补贴          "overTime": 300,　　　　　　salary.overtime_salary
    实发工资          "real_salary": 6034.05,　　salary.real_salary
    扣除工资          "takeOut": 365.95,
    扣税　　          "tex": 31.95,　　　　salary.tax
    出行补贴          "travel": 200　　welfare.travel_salary
    */

    /*select salary.salary_id,contract.base_salary,salary.leave_fine,salary.illegal_fine,salary.pay_time,employee.emp_name,account.emp_num,welfare.food_salary,
    welfare.house_salary,salary.month_bonus,salary.overtime_salary,salary.real_salary,salary.tax,welfare.travel_salary
    from contract,salary,employee,account,welfare
    WHERE salary.emp_id=employee.emp_id and employee.emp_id=contract.emp_id and account.emp_id=employee.emp_id and welfare.welfare_id=employee.welfate_id
    and emp_name LIKE '%j%' and dept_id=1 and pay_time LIKE '%2019-09%';*/

}
